set hive.exec.dynamic.partition=true;--动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=20;--每天生成 20 个分区
set hive.exec.max.dynamic.partitions.pernode=20;--每天生成 20 个分区
insert overwrite table jms_dim.dim_yl_nwm_cost_config
select
id
,network_code
,network_name
,start_time
,end_time
,create_by
,create_by_name
,create_network_code
,create_network_name
,create_time
,update_by
,update_by_name
,update_time
,is_submit
,submit_by
,submit_by_name
,submit_network_code
,submit_network_name
,submit_time
,is_verifier
,verifier_by
,verifier_by_name
,verifier_network_code
,verifier_network_name
,verifier_time
,type
,finance_code
,finance_name
,config_type_code
,config_type_name
,code
,name
,belong_type
from jms_ods.yl_nwm_cost_config
where dt= '{{ execution_date | cst_ds }}'
distribute by 1 ;